At least two people have died and many more are still missing following torrential rain on the North Island