A counselor from Moore Public Schools resigned after inviting a registered sex offender to visit an elementary school, prompting an immediate suspension and investigation, according to the district.