Conselor or councillor? Isn’t a councillor a member of a government council? Or is that another US/UK/Canada/wherever spelling discrepancy I’m not aware of?
As for your question, it depends on your idea of “fun.” You almost certainly need a degree to become a guidance counselor – at least an undergraduate degree, but most have higher degrees. And you should probably enjoy working with kids, and helping people in general. Guidance counselors in elementary and middle schools do different things than a high school guidance counselor does. In my high school, all they really did was class schedules and college/career planning. Sure, you could go talk to them if you had a problem, but most of their time was spent on academic/career planning. For younger kids, there’s still coursework planning, but I think they deal a lot more with bullying and other problems between kids.