Harrogate district prepares for heatwave as red weather warning issued