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 ruling on the ablution of one who cuts his nails, and is it permissible to cut them before the ritual bath for major impurity (janabah)?
Cutting nails does not invalidate ablution, and it is permissible to cut them before the ritual bath for major impurity. And Allah the Almighty knows best.
What is the ruling on swallowing phlegm while fasting?
If a fasting person intentionally swallows phlegm, their fast is invalid, as it is possible to avoid it.
However, if they swallow it unintentionally, their fast remains valid.
Phlegm is impure and should be avoided.