Temperatures will tumble this weekend with the weather feeling noticeably cooler as the fifth widespread heatwave of the year comes to an end.