The weather bureau has issued a yellow alert for much of Abu Dhabi and Dubai, forecasting rain and low visibility on Thursday