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.
I want to buy a house by having a loan from a bank?
If taking a loan from usrious banks it is impermissible; on the other hand, if this took place through Islamic ones then it is permissible to get the loan, since Allah the Most Exalted Said (What means): "And Allah has made buying lawful and forbidden usury (riba)." And Allah Knows Best.
Is it permissible to repeat the Istikhara (seeking guidance) prayer, and is it a condition that one should sleep after offering it?
All perfect praise be to Allah,The Lord of The Worlds Istikhara is offered once, but it is permissible to repeat it, and sleeping after offering it is not a condition for its validity. And Allah Knows Best.
Is it permissible to openly announce the engagement of a woman who is in her waiting period (iddah)?
It is not permissible to openly announce the engagement of a woman in her waiting period (Iddah), but it is permissible to hint (imply) at it if she is in her waiting period after the death of her husband. And Allah Knows Best.