David Black's resignation comes after the government said the water regulator will be abolished to create a new watchdog.