Long-awaited heatwave sees hottest August day in three years but rest of summer will be rainy, unsettled and cold