Sheffield has been warned it could face a weekend of disruption, with a storm set to hit the city.