After a summer dominated by heat and successive heatwaves, the UK is set for a much wetter spell.