A man is dead and another is in hospital with hypothermia after the boat they were on capsized off Perth's northern coast.