What is the ruling on public street water if it gets on a person's clothes or body?
The default ruling is that public street water is pure (tahir). If one is certain of its impurity (najasa), then a small amount that gets on the lower part of a person's clothes or body is overlooked (excused). And Allah the 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 correct point at which to raise the hands when standing up for the third rak‘ah (after the middle tashahhud)?
All praise is due to Allah, and peace and blessings be upon our master, the Messenger of Allah ﷺ.
Raising the hands while saying the takbīr [when rising for the third rak‘ah] is a recommended sunnah, and omitting it does not affect the validity of the prayer. The proper time for this is after rising from the middle tashahhud, once one has fully stood up.
It is stated in I‘ānat aṭ-Ṭālibīn (Vol.1/P.158): "His statement, 'and rising from the first tashahhud' — meaning, this manner [of raising the hands] is also a sunnah when he rises from the first tashahhud, that is, when he stands upright from it.
Consider [the question]: when precisely does the raising of the hands begin? Is it at the very start of rising from the first tashahhud, or after he has reached the minimum position of rukū‘ [i.e., once fully upright]? The apparent, [correct] view is the latter — even though the outward wording [of the text] might suggest the former — because at the very start of his rising, he is still relying on both hands [to push himself up, and therefore cannot yet raise them]."
It is stated in ‘Umdat as-Sālik (p. 53): "If his prayer extends beyond two rak‘ahs, he sits after them in the iftirāsh position, recites the tashahhud, and sends blessings upon the Prophet ﷺ alone, without [mentioning] his family [at this point]. He then stands while saying the takbīr, supporting himself with his hands; and once he has stood upright, he raises them level with his shoulders." And Allah, the Exalted, knows best.
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.