How does the person praying perform the prostration (Sujud)?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
It is an act of Sunnah for the person praying to descend for prostration (Sujud) by placing their knees first, then placing their hands on the ground, and then placing their nose and forehead simultaneously. It is obligatory that the toes of the feet be on the ground, directed towards the Qibla. And Allah the Exalted 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 ruling on eating or drinking during the second Adhan?
It is not permissible to eat or drink during the second Adhan because it announces the break of dawn and the obligation to start fasting. Allah Almighty says {what means}:"and eat and drink until you can discern the white streak of dawn against the blackness of night." [Al-Baqarah/187].
Whoever eats or drinks during this time invalidates their fast, and they must refrain from eating for the rest of the day and make up for the missed fast later.
Is it permissible for one who sacrifices on behalf of another, with the latter's permission, to eat from the sacrifice?
It is permissible for someone who sacrificed on behalf of another with their permission to eat from it with their permission, and they stand in their place (act as their representative) in distributing it.
It is stated in Nihayat al-Muhtaj ila Sharh al-Minhaj (Vol.8/P.141): "And he—meaning the one sacrificing on his own behalf, provided he has not apostatized—has the right to eat from a voluntary sacrifice and his sacrificial gift; rather, it is recommended. As for an obligatory sacrifice, it is forbidden for him to eat from it, whether it was designated as such initially or as a liability in his dhimmah. And excluded by what has preceded is if he sacrifices on behalf of another, or if he apostatized, then it is not permissible for him to eat from it, just as it is absolutely impermissible to feed a disbeliever from it."(The text I found indicates the impermissibility of eating) ???
And it is stated in Hashiyat al-Jamal ‘ala Sharh al-Manhaj (Vol.5/P.262): "If a person offers a sacrifice on behalf of a living person with their permission, does he act as their representative in distributing it—on the grounds that permission to sacrifice is permission to distribute it—or does it depend on their explicit permission? This requires consideration, but the first view is not far-fetched." And Allah the Almighty knows best.