What is the Du`a (supplication) of Istikhara (guidance prayer)?
O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."
A person is sponsoring an orphan and pays the sponsorship monthly. Is it permissible to pay this month's sponsorship from zakat money?
It is permissible to pay the orphan's sponsorship from zakat money if the orphan is poor and has no one to support them. The person must intend to count it as part of their zakat when paying the money. And Allah 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.
I see horrible dreams although I perform the prescribed prayers, what do you make of that?
All perfect praise be to Allah the Lord of the Worlds. May His peace and blessings be upon our Prophet Mohammad and upon all his family and companions.
Be mindful of Allah while awake and he will safeguard you from whatever evil you see while asleep. We advise you to make the pre-sleep supplications. And Allah The Almighty Knows Best.