A car is left partly submerged in Sheffield and parts of Rotherham Hospital are flooded as storms hit.