Footage captures the moment a burst pipe shot water and pebbles 20ft into the air