Is it obligatory to have an intention (niyyah) for every prayer?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
It is obligatory for the worshiper to have a specific intention (Niyyah) for every prayer, meaning they must consciously intend the act of worship they are performing. The intention is a pillar (Rukn) of the prayer, and the prayer is not valid without it. It is not a requirement to utter the intention verbally; rather, doing so is considered a recommended Sunnah. And Allah the Exalted knows best.
How is night prayer offered?
Night prayer is offering voluntary prayer after Maghrib and before Fajr (Dawn). As for Tahajjud, it is offering voluntary prayer at night after waking up voluntarily, and for Allah`s sake as He Says (What means): "And pray in the small watches of the morning: (it would be) an additional prayer (or spiritual profit) for thee: soon will thy Lord raise thee to a Station of Praise and Glory!" [Al-Isra`/79]. Offering Tahajjud is better than offering voluntary prayer before going to bed.
What should the one performing the slaughter say at the time of slaughtering 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 to say the following supplication at the time of slaughtering the 'aqīqah:
"Bismillāhi wallāhu Akbar, Allāhumma laka wa ilayka, hādhihi 'aqīqatu fulān."
("In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of [the child's name].")
This is based on what al-Bayhaqī narrated in Al-Sunan al-Kubrā (Vol.9/P.511), that the Prophet ﷺ said: "Slaughter it in his name and say: In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of so-and-so."
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.