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.
Is it permissible for a woman to shake hands with her brother-in-law?
It is forbidden for the woman to shake hands with her brother-in-law because he isn`t a Mahram (unmarriageable) of hers.
What should one do if they see someone deliberately eating or drinking openly during Ramadan?
They must enjoin what is right and forbid what is wrong. If they fear harm from that person, they should disapprove of it in their heart but avoid sitting with them if possible. It is also preferable to seek the help of the authorities to prevent them from doing so.
Is it permissible to slaughter sacrificial animals in public squares and streets?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
The slaughtering of sacrificial animals (udhiyah) should take place in locations designated for slaughter, such as abattoirs (slaughterhouses), or in sites allocated by the relevant authorities for this purpose.
It is not permissible to perform slaughtering in a random or haphazard manner—such as in public squares, on roadsides, or in front of houses—in a way that creates health hazards, causes public nuisance, or endangers public safety. And Allah Almighty knows best.