What should one do if they see someone deliberately eating or drinking openly during Ramadan?
They must enjoin what is right and forbid what is wrong. If they fear harm from that person, they should disapprove of it in their heart but avoid sitting with them if possible. It is also preferable to seek the help of the authorities to prevent them from doing so.
What is the ruling on istinja' after urination, and is it done with water and soap or with water only?
Istinja' from urine and stool is obligatory. It is permissible to perform istinja' with water alone, or with toilet paper alone. The best way is with toilet paper then water. If one wishes to suffice with one of them, then water is better. And Allah the Almighty knows best.
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.
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.