Emergency water works have forced a city centre route to close - just weeks after it reopened following a multi-million-pound facelift project.