Northern Ireland’s water infrastructure system is under “significant strain” due to years of inadequate investment, MLAs have been told.