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.
Does sacrificing one sheep avail for the entire household?
Praise be to Allah, and peace and blessings be upon our master, the Messenger of Allah.
In Islamic jurisprudence, the sacrifice (Udhiyah) is considered a Communal Sunnah (Sunnah Kifayah) for the members of a single household who share the same financial support.
If one member of the household performs the sacrifice—even if they are not the primary breadwinner, such as the wife or one of the children—the religious request is fulfilled on behalf of the entire household. This is similar to the Funeral Prayer (Salat al-Janazah), where the obligation is dropped for the community if some perform it.
While the communal request is satisfied by one person's action, the specific spiritual reward (Thawab) for the act of worship belongs only to the person who sacrificed, unless that individual explicitly intends to include the other family members in the reward.
A single sacrifice also avails for a man who is married to more than one wife. And Allah the Almighty knows best.
Is it a condition for I‘tikaf to be performed in the mosque?
Yes, for I‘tikaf to be valid, it must be performed in a mosque. I‘tikaf is not valid if performed at home or elsewhere.
Where should a woman following her husband or another man in prayer stand?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
If a single woman prays with a man—whether she is his wife or a non-mahram (Ajnabiyyah)—the Sunnah is for her to stand behind the Imam and be shielded by him. If the Imam is leading both a man and a woman, the man should stand to the Imam's right, and the woman should stand behind the male follower (Muqtadi). In this way, she is shielded from the Imam by the male follower and remains at a distance from the follower and his line of sight. And Allah the Exalted knows best.