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 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.
What is the ruling on sacrificing a castrated animal or one with a missing tail?
Praise be to Allah, and peace and blessings be upon our master, the Messenger of Allah.
It is permissible to sacrifice a castrated sheep; as it has been established that the Prophet (peace be upon him) sacrificed:
"...two large, fat, horned, white-and-black, castrated rams (Mawju'ayn—meaning having crushed testicles)." [Narrated by Ibn Majah in his Sunan].
It is not permissible to sacrifice an animal that is missing its tail, or udder due to being cut off. This is in contrast to an animal that was naturally born without a tail, or udder; such an animal is valid for sacrifice. And Allah the Almighty knows best.
What is the ruling on congregational prayer performed outside the mosque, and is it a condition that it be performed in a mosque in order to attain the full reward?
All praise is due to Allah, and peace and blessings be upon our master, the Messenger of Allah ﷺ.
It is not a condition for attaining the reward of congregational prayer that it be performed in a mosque; however, a Muslim should still be keen to perform his prayers in the mosque, so as not to miss out on immense reward. This is due to the virtue of the mosque and of spending time there (i‘tikāf), the typically larger number of worshippers present, and the additional reward gained through walking to and from the mosque. On the authority of Abū Hurayrah (raḍiyallāhu ‘anh), the Messenger of Allah ﷺ said: "Whoever purifies himself in his house, then walks to one of the houses of Allah to fulfill one of the obligations Allah has prescribed, one of his steps will erase a sin, and the other will raise him a degree [in status]." (Related by Muslim)
Whoever misses congregational prayer at the mosque should still strive to pray in congregation at his workplace, or together with the members of his household. And Allah, the Exalted, knows best.