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.
Is it permissible to offer mandatory prayer while sitting?
All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions. Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah 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 it valid for the 'aqīqah to be performed using the newborn child's own wealth?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is not permissible for the guardian to perform the 'aqīqah using the newborn child's own wealth, because the 'aqīqah is a voluntary act of giving (tabarru'), and a guardian is prohibited from making voluntary expenditures from the child's wealth. Should he do so, he becomes financially liable for what he spent. And Allah Almighty knows best.