A failure to reform how Northern Ireland’s water and wastewater infrastructure is funded could be “catastrophic” for the region’s economy, MLAs have been told.