What is the ruling on staring at the Holy Ka'abah?

All perfecy praise be to Allah, The Lord of The Worlds and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.

Staring/looking at the Holy Ka'abah is an act of worship even if this took place while performing a prayer, since Al-Baihaqee stated that the Prophet (PBUH) said: " Staring at the Holy Ka'abah is an act of devotion." [Sho'aab Al-Imaan]. And Allah Knows Best.

What is the best manner in distributing the meat of the Aqeeqah?

It is better to divide all of it as cooked meat amongst the poor and the needy. Dividing it into three portions is a Sunnah, but it is permissible to keep all of it provided that a portion, even a small one, is given to the poor and needy (one kilo for example).

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 one who forgot to offer the second Sajda during congregational prayer, and remembered it before the end of the prayer do?

All perfect praise be to Allah, The Lord of The Worlds.                                                                                                                                                          Whoever forgets a pillar of prayer while in congregation must follow the lead of the Imam, and after the latter offers Tasleem, he should offer one Rakah, then perform Sujood As-Sahw (prostration of forgetfulness). And Allah Knows Best.