This is a fountain just outside the Central Souk in Sharjah. Water fountains and other types of artificial waterfalls are very common in the cities, often used to decorate roundabouts, malls, parks and even airports such as the one in Dubai!
All praises and thanks are to Allaah (subhaanahu wata'aalaa) alone