At least nine people have died after getting into difficulty in open water during the record-breaking UK heatwave this week.