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 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 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.
Is it permissible for a woman to sit with her brothers-in-law?
It is impermissible for a woman to sit with her brothers-in-law, and it is also impermissible for a person to have a Khulwa (seclusion) with his sister-in-law.