Not wanting to move somewhere, for whatever reason, however silly, is a good enough reason not to move there. Your husband can't make you move if you don't want to.
But I do think your reasons sound rather silly.
If your son is nearly old enough to go clubbing then is he not thinking about leaving home soon anyway? Presumably he's not planning on staying in his childhood home in your safe little village for the rest of his life. So he probably wouldn't even live there for very long, and where he lives after he leaves home will not be within your control.
Personally I'd be more concerned about potentially relocating your family at an important time in your children's education if they have GCSEs or A-levels coming up.
Leeds is a big city surrounded by gorgeous countryside, including lots of lovely little villages. I'm sure you could find a village which is just as nice and safe as the one you currently live in, and probably afford a much nicer house if you are currently in an expensive part of the country.
In your position I'd be far less focused on Leeds itself (which, like any city, has nice areas and less nice areas) and more on whether moving there at this time in your lives is going to disrupt your children's education or isolate you from friends and family.
How old are your children exactly and what do they think about the idea?