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.
What is the ruling on sacrificing a castrated animal or one with a missing tail?
Praise be to Allah, and peace and blessings be upon our master, the Messenger of Allah.
It is permissible to sacrifice a castrated sheep; as it has been established that the Prophet (peace be upon him) sacrificed:
"...two large, fat, horned, white-and-black, castrated rams (Mawju'ayn—meaning having crushed testicles)." [Narrated by Ibn Majah in his Sunan].
It is not permissible to sacrifice an animal that is missing its tail, rump, or udder due to being cut off. This is in contrast to an animal that was naturally born without a tail, rump, or udder; such an animal is valid for sacrifice. And Allah the Almighty knows best.
Which is better in night prayer: long standing (Qiyam) or long prostration (Sujood)?
Long standing (Qiyam) is better in prayer. However, a Muslim should also observe tranquility and composure in their prayer.