After and exceptional summer of heatwaves and drought, the weather will turn wetter and cooler this week, as Simon King explains