You're a bit stuck in the middle there. I lived at Oxenhope for a while but I've never flown in - it looks interesting
I think both Sherburn and Blackpool would be worth a look. I've trained at, and can recommend both.
Sherburn is a club, Blackpool is a quiet commercial airport with several commercial training organisations. I can personally recommend Westair and Flight Academy Blackpool. The latter also run non -equity groups which may be of interest when you finish training.
If you would like more details send me a PM