A Master's degree in a counseling-related field is definitely required at the college/university level. You can check out various job listings
here. If you're talking about high school, most academic advisors will have degrees in school counseling. My guess is that there may be high school districts out there where you can do this with a four-year degree; best bet is to contact the school districts & see what they say.