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 of Islamic Law on eating or drinking during the circumambulation?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
It is disliked (makrūh) to eat or drink during the circumambulation (ṭawāf).
Shaykh al-Islām Imām al-Nawawī states in al-Majmūʿ: "It is disliked to eat or drink during ṭawāf, and the dislikedness of drinking is lighter. Neither of them, nor both together, invalidates the ṭawāf. Al-Shāfiʿī said: 'There is no objection to drinking water during ṭawāf, and I do not consider it sinful; however, I prefer that it be avoided, as refraining from it is more befitting in terms of proper conduct.' Among those who explicitly stated the dislikedness of eating and drinking, and that drinking is the lesser of the two, is the author of al-Ḥāwī."
If, however, a person is in genuine need of drinking, then there is no dislikedness in doing so. In any case, the ṭawāf itself remains valid. And Allah the Almighty knows best.
Is it a condition that one should offer two sacrifices for a male newborn?
It is desirable to offer two sheep for a male newborn, and one for a female newborn. Offering one sheep for the male newborn is also permissible as it observes the Prophet`s Sunnah in this regard.
Is it valid for the 'aqīqah to be performed using the newborn child's own wealth?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is not permissible for the guardian to perform the 'aqīqah using the newborn child's own wealth, because the 'aqīqah is a voluntary act of giving (tabarru'), and a guardian is prohibited from making voluntary expenditures from the child's wealth. Should he do so, he becomes financially liable for what he spent. And Allah Almighty knows best.