Storms set to bring an end to sunny spell