What is the ruling on eating and drinking at night after making the intention? Is it necessary to renew the intention?
Eating and drinking at night, even after making the intention (for the next day), does not affect the fast, and it is not necessary to renew the intention after eating and drinking.
Is it Sunnah to cook the meat of the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is Sunnah not to distribute the meat of the 'aqīqah raw. Rather, it is recommended to cook it with something sweet — such as raisins or honey — as a good omen and expression of hope for the sweetness of the newborn's character and conduct throughout their life. And Allah Almighty knows best.
What should one do if they see someone deliberately eating or drinking openly during Ramadan?
They must enjoin what is right and forbid what is wrong. If they fear harm from that person, they should disapprove of it in their heart but avoid sitting with them if possible. It is also preferable to seek the help of the authorities to prevent them from doing so.
Does buying meat equivalent to the weight of a slaughtered animal and distributing it avail for an udhiyah?
Praise be to Allah, and prayers and peace be upon our Master the Messenger of Allah.
That does not avail for the sacrifice (uḍḥiyyah), because the sacrifice necessarily requires slaughtering an animal from the category of anʿām (camels, cattle, and sheep/goats) within a specified time.
Rather, that is considered a form of charity (ṣadaqah) for which one is rewarded, but not an udhiyah. And Allah Almighty knows best.