I work mostly in Leeds and live just outside Huddersfield, out towards Holmfirth. The commute into Leeds is tolerable if you can be flexible in your hours. There’s plenty of riding from my front door, and it’s a short drive over to Dark Peak. Some serious road climbs round here if you’re that way inclined (soon to be featured on the Tour de France). When my tenancy’s up for renewal I may look for something down the road in Meltham. Marsden would be great, but might be a bit of stretch for commuting.
North of the M62 (Hebden, etc) is also nice.
Pudsey, horsforth, etc are OK if you need to be close to Leeds, but if you want to live in the country side proper, rather than on the outskirts of a city, then you need to get a fair way from Leeds.
If you want hills then you need to be west of Leeds towards the Pennines.
If you’re driving in and working normal office hours then it’s a ball ache which ever way you’re coming in. The M62 from Bradford, and the M1 from Wakefield are dire.