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 existence of cattles' marketplace of (Sheeps, cows and chickens ) inside a graveyard?
Graves must be respected, and it is not permissible to sit on them or show any disrespect. Establishing a marketplace within a cemetery is undoubtedly a form of disrespect to the deceased and is not permissible. Such actions should not be tolerated. And Allah Knows Best.
What should a person who doubted having missed a pillar of prayer do?
All praise be to Allah, The Lord of The Worlds. The prayer of one who doubts having missed one of its pillars is valid, and nothing is due on him/her since having a doubt after offering the act of worship doesn`t undermine its validity. 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.