Who is the one required to slaughter 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 for the 'aqīqah to be slaughtered by the guardian of the newborn — the one upon whom the child's financial maintenance is obligatory — provided he is financially capable of doing so. 'Alī ibn Abī Ṭālib, may Allah be pleased with him, reported: "The Messenger of Allah ﷺ performed the 'aqīqah for al-Ḥasan with one sheep." — Narrated by al-Tirmidhī. 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 one who slept while firmly seated on the ground, regarding nullification of ablution?
The default ruling regarding sleep is that it nullifies ablution. An exception to this is one who slept while firmly seated on the ground; his ablution is not nullified by sleep if he wakes up while still firmly seated on the ground. And Allah the Almighty knows best.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.