A senior Queensland Health bureaucrat has resigned “for personal reasons” amid a Crime and Corruption Commission investigation.