Bin off the stations and ride into work!
Failing that, If Stations are a big thing I’d suggest Horsforth, Cross Gates (perhaps less so, though for no specific reasons) and Morley.
There is mountain biking out of most doors. The steps out of my kitchen are sick in the wet and the garden is properly muddy! Leeds as a city is quite woody, with several large parks riddled with cheeky and legit trails, you can pretty much ride from Leeds city centre to the dales mostly off road!
I appreciate you are thinking more “Epic Trails” type riding from the door, in which case Bingley, Skipton or Hebden is the answer, but Leeds trails have a lot to offer local riders and public transport is a PITA (things are different up here laddy!)
If you fancy going for a ride when you move up here, feel free to give me a shout, I’ll show you all the little local bits that can be tied together to make interesting little rides!