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, rump, or udder due to being cut off. This is in contrast to an animal that was naturally born without a tail, rump, or udder; such an animal is valid for sacrifice. And Allah the Almighty knows best.
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.
Is the one offering the sacrifice liable if its meat spoils?
Praise be to Allah, and prayers and peace be upon our Master the Messenger of Allah.
If the meat (of the sacrifice) spoils due to the negligence of the one offering the sacrifice in preserving it, or due to improper storage, then he is liable to compensate for the portion due to the poor (which is estimated as half a kilogram of meat). If the sacrifice was a vowed (mandatory) one, then he is liable for all of it.
However, if he was not negligent, then there is no liability upon him, because its ruling is the ruling of a trust (like an item left in someone's care). And Allah Almighty knows best.
Who is the one required to slaughter the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is Sunnah for the 'aqīqah to be slaughtered by the guardian of the newborn — the one upon whom the child's financial maintenance is obligatory — provided he is financially capable of doing so. 'Alī ibn Abī Ṭālib, may Allah be pleased with him, reported: "The Messenger of Allah ﷺ performed the 'aqīqah for al-Ḥasan with one sheep." — Narrated by al-Tirmidhī. And Allah Almighty knows best.