Temperatures to cool for some after six water deaths in record-breaking UK heat