I'm pretty sure Glittergal moved to your area last year, but I haven't seen her posting in ages- she moved to Harrogate from the US.
I know the area but not well, iykim? There isn't anywhere I'd refuse to live around there, but be aware that it might turn out to be an advanced class in racism in action up there

All of the multicultural crap that our government talks has led to frustration between particularly the black and asian communities, and the British National Party have a strong foothold.
That said, there isn't anywhere that I'd refuse to live seeing as your family are so small. Deprived areas over here have a huge amount of funding pushed into them, so the SureStart centres tend to be big and active and have a lot to do, and I love Leeds city centre- never spent much time in Bradford. The pretty little villages may or may not be active during the day, so pick yours carefully.
Good luck!