Police at scene of major leak leaving hundreds with no water