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 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, or udder due to being cut off. This is in contrast to an animal that was naturally born without a tail, or udder; such an animal is valid for sacrifice. And Allah the Almighty knows best.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
Who is responsible for performing the aqiqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
The one upon whom the 'aqīqah is incumbent is whoever is obligated to financially maintain the newborn — whether the father, paternal grandfather, or mother. It is to be performed from their own wealth, not from the wealth of the newborn child.
As for one upon whom the financial maintenance of the newborn is not obligatory, they may not perform the 'aqīqah except with the permission of the one upon whom it is obligatory — namely, the father. And Allah Almighty knows best.