Some areas in the country will have the ‘first meaningful rain for a long time’, the Met Office said, after weeks of heatwaves.