Wild footage has captured a major water pipeline bursting in Sydney, flooding nearby homes with torrents of water.