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 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.
What is the ruling on mentioning Allah`s name upon slaughtering an animal?
In the Name of Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is a Sunnah (prophetic tradition) for the person slaughtering to say: "Bismillah" (In the Name of Allah), though the most complete and perfect phrasing is to say: "Bismillah ar-Rahman ar-Rahim" (In the Name of Allah, the Most Gracious, the Most Merciful). This is in accordance with the words of Allah Almighty: "So eat of that [meat] upon which the name of Allah has been mentioned." (Al-An'am/118)
However, pronouncing it is not an obligatory requirement (Wajib). If someone omits it—whether deliberately or out of forgetfulness—the meat remains entirely lawful (Halal) to eat, though purposely omitting it is considered disliked (Makruh). And Allah the Almighty 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.