A Met Office storm warning has been issued for Sheffield, with gales forecast later this week.