Dozens of people have been evacuated from their homes after a water main burst, causing severe flooding in north London.