As a county executive, he pushed through a policy that bans transgender athletes from using county sports facilities