Northern Territory Health has issued an urgent boil water alert for Greater Darwin and Palmerston after heavy flooding at the Darwin River Dam compromised the region's primary supply.