Which takes precedence: the 'aqīqah or the uḍḥiyyah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
The 'aqīqah is an act of worship through which a servant draws closer to Allah the Almighty in gratitude for the blessing of a newborn child. It is a confirmed Sunnah for those who are financially capable, and Allah does not burden any soul beyond what it can bear.
However, the uḍḥiyyah takes precedence, as it is a confirmed Sunnah established from the Prophet ﷺ through stronger and more numerous narrations — indeed, the Ḥanafī scholars hold it to be obligatory. Furthermore, its time is narrow and limited, expiring with the passing of the days of Eid, whereas the 'aqīqah may be delayed until one becomes financially capable of performing it.
And Allah Almighty knows best.
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.
What is the Islamic ruling on eating from the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is recommended (mandūb) to eat from the 'aqīqah, unless it was vowed (mandhūrah). If the 'aqīqah was made as a vow, then it is prohibited to eat from it, and it becomes obligatory to distribute the entirety of it in charity to the poor. And Allah Almighty 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.