What is the ruling on using moisturizing creams on the skin during the day in Ramadan?
Using moisturizing creams on the skin does not break the fast because they do not enter the body cavity (jauf). Any absorption that occurs through the skin pores does not count as entering through an open passage.
What is the ruling on public street water if it gets on a person's clothes or body?
The default ruling is that public street water is pure (tahir). If one is certain of its impurity (najasa), then a small amount that gets on the lower part of a person's clothes or body is overlooked (excused). And Allah the Almighty knows best.
Is it a condition for I‘tikaf to be performed in the mosque?
Yes, for I‘tikaf to be valid, it must be performed in a mosque. I‘tikaf is not valid if performed at home or elsewhere.
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.