Almost 300,000 people are to be notified that their drinking water supplies have excessive levels of a toxin linked to cancer.