Ireland needs “substantial” investment in waste water treatment, the EPA report said.