I LOVE knaresborough, I live in harrogate but if it were possible to move to k-borough, i would.
Pros:
Beautiful, all year round, lots of walks and countryside around.
It's a small town, everyone knows everone!
I don't think it's sleepy - they have a fab arts and music fest in summer, a Gorgeous Christmas fair, and Easter fair, medieval day, the world-famous bed-race, fun runs, their own theatre, a thriving busy children's centre with loads of activities, some nice restaurants and pubs, concernts, good primaries, a very popular secondary school, a great child-friendly swimming pool, lots of interesting little shops and the wonderful market. I do lots of shopping in market. In fact we spend lots of our leisure time in Knaresborough rather than harrogate.
The train to leeds and york and harrogate is a definite plus too!
Cons - it's a small town...:) every knows everyone!
.Anecdotally, I have heard from other parents if your child is buillied at primary, there is no escape at secondaRY level as all the children go to that secondary.