Temperatures will drop across much of the UK over the weekend, as a record-breaking heatwave gives way to cloudy skies and rain, the Met Office has said.