Water supplies serving more than 800,000 people are at risk of contamination and in need of urgent investment, the Environmental Protection Agency has warned.