Thousands of homes are still facing intermittent water supplies after record-breaking temperatures and increased demand prompted widespread issues.