Dramatic video shows cars battered by water erupting from burst pipe