A water utility giant has apologised for the disruption caused by 24-hour tanker operations on a busy street.