High-ranking Navy officer resigns due to sexual misconduct allegations