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.
What is the ruling on someone who insults or deceives others while fasting?
Insulting or deceiving others is forbidden (haram) and diminishes the reward of fasting.
The Prophet ﷺ warned against deception, saying: "Whoever deceives is not one of us." [Narrated by Al-Tirmidhi]
However, their fast remains valid despite the sin.
What is the ruling on performing dry ablution (tayammum) on a wall or stone?
One of the conditions for tayammum is that it be with pure, clean dust (soil). It is not valid to perform tayammum by striking stones, a wall, sand that has no dust (i.e., that does not produce dust), pebbles alone, or clay, as these are not from the earth or its same category. And Allah the Almighty knows best.