A water company has apologised to residents after a burst sewer pipe at a pumping station forced tankers to transport sewerage to a mains system.