After the country has been dried up by heatwaves and hot weather, a spell of rain is on the way, according to the Met Office