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 of Islamic Law if the follower (maʾmūm) stands up for the third rakʿah out of forgetfulness while the imam has sat for the middle tashahhud?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
If the imam sits for the tashahhud while the follower (maʾmūm), out of forgetfulness, stands up for the third rakʿah, he is obliged to return to his sitting position, since following the imam is obligatory. In this case, no prostration of forgetfulness (sujūd al-sahw) is required of him. If, however, he fails to return, his prayer is rendered invalid.
Shaykh al-Islām Imām Zakariyyā al-Anṣārī, may Allah have mercy upon him, states: "If the follower stands up alone out of forgetfulness, he is obliged to return, since following the imam is obligatory... If he does not return, his prayer is rendered invalid, due to his departure from what is obligatory." [Asnā al-Maṭālib,Vol.1/P.190] And Allah the Almighty knows best.
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.
Does the time of Fajr (dawn) prayer start after the first Athaan (call for prayer), or the second one?
All perfect praise be to Allah,The Lord of The Worlds The time of Fajr prayer starts after the second Adhan. And Allah Knows Best.