Is supplicating in Qunoot, at times of affliction, during obligatory and voluntary prayer a Sunnah, and should it be done before Rukoo` (bowing), or after it?
At times of affliction, it is a Sunnah that Muslims supplicate in Qunoot after the final Rukoo` of each obligatory, or voluntary prayer as individuals, or in congregation.
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.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
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.