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 on eating or drinking during the circumambulation?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
It is disliked (makrūh) to eat or drink during the circumambulation (ṭawāf).
Shaykh al-Islām Imām al-Nawawī states in al-Majmūʿ: "It is disliked to eat or drink during ṭawāf, and the dislikedness of drinking is lighter. Neither of them, nor both together, invalidates the ṭawāf. Al-Shāfiʿī said: 'There is no objection to drinking water during ṭawāf, and I do not consider it sinful; however, I prefer that it be avoided, as refraining from it is more befitting in terms of proper conduct.' Among those who explicitly stated the dislikedness of eating and drinking, and that drinking is the lesser of the two, is the author of al-Ḥāwī."
If, however, a person is in genuine need of drinking, then there is no dislikedness in doing so. In any case, the ṭawāf itself remains valid. And Allah the Almighty knows best.
Should a prayer performer who forgets to offer the middle Tashahod (saying ash-hadu anala ilaha ila-alah) offer Sujood As-Sahw (prostration of forgetfulness)?
He/she should offer two prostrations of forgetfulness at the end of the prayer. And Allah Knows Best.
What is the ruling on eating or drinking during the first Adhan?
It is permissible to eat and drink during the first Adhan because it takes place before the break of dawn. The purpose of this Adhan is to notify Muslims of the approaching dawn so they can prepare to stop eating when they hear the second Adhan.