Is it valid to perform the obligatory prayer while sitting?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Standing (Al-Qiyam) while having the ability to do so is one of the pillars (Arkan) of the prayer; the obligatory (Faridah) prayer is not valid without it. However, whoever is unable to stand may pray sitting down. As for voluntary (Nafilah) prayers, it is permissible to pray them sitting even if one is able to stand, but the one sitting receives half the reward of the one who prays standing. And Allah the Exalted knows best.
Is it required for a discerning child to make the intention at night if they wish to fast?
If a discerning child wishes to fast during Ramadan, they must make the intention at night because intention is one of the pillars of fasting, even though fasting is not obligatory for them.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.
Who is responsible for performing the aqiqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
The one upon whom the 'aqīqah is incumbent is whoever is obligated to financially maintain the newborn — whether the father, paternal grandfather, or mother. It is to be performed from their own wealth, not from the wealth of the newborn child.
As for one upon whom the financial maintenance of the newborn is not obligatory, they may not perform the 'aqīqah except with the permission of the one upon whom it is obligatory — namely, the father. And Allah Almighty knows best.