An alarm bell was sounded over the state of waste water infrastructure in Northern Ireland and the impact on waterways.