Does sacrificing one sheep avail for the entire household?
In the Name of Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
Offering an Udhiyah (sacrificial offering) is a communal Sunnah (Sunnah Kifayah) for members of the same household, provided that their financial maintenance is undertaken by a single provider. By "communal Sunnah," we mean that when one person performs it, the religious recommendation is fulfilled on behalf of the entire household, though the spiritual reward itself belongs uniquely to the one who offered it.
Therefore, if any member of the household performs the sacrifice—even if it is someone who is not legally responsible for the household's expenses, such as the wife or one of the children—the recommendation is fulfilled for everyone in that home. However, the reward does not automatically extend to the other members unless the person offering the sacrifice explicitly intends to share the reward with them—similar to how performing a funeral prayer (Janazah) fulfills the communal obligation for everyone, yet the specific reward is earned by those who actually prayed.
Additionally, a single sacrifice is sufficient for a man who is married to more than one wife. And Allah the Almighty Knows Best.
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 obligatory to have an intention (niyyah) for every prayer?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
It is obligatory for the worshiper to have a specific intention (Niyyah) for every prayer, meaning they must consciously intend the act of worship they are performing. The intention is a pillar (Rukn) of the prayer, and the prayer is not valid without it. It is not a requirement to utter the intention verbally; rather, doing so is considered a recommended Sunnah. And Allah the Exalted knows best.
Is it a condition for the mosque where I‘tikaf is performed to hold Jumu‘ah prayers?
No, it is not a condition for the mosque where I‘tikaf is performed to have Jumu‘ah prayers. However, if a person vows to perform continuous I‘tikaf, and Jumu‘ah occurs within that period, then they must observe I‘tikaf in a mosque where Jumu‘ah is held so that they do not break their continuity by leaving for Friday prayer.