Much of the UK is in for a reprieve from the hot weather as the third heatwave this summer starts to come to an end.