The best scheduled scenic train journey in Yorkshire, and probably England, is the Settle-Carlisle route over the massive but elegant Ribble Viaduct. Setting off from Leeds, the gritty mill towns unfold as the hills rise up, a prelude to the drama of Yorkshires Three Peaks and the panoramic views that motorists, and even walkers, never get. Ingleborough, Pen-y-ghent and finally the very flanks of Great Whernside fill the windows, making an assault on one of them almost irresistable followed by a yorkshire pint at a village pub, perhaps the welcoming Crown at Horton.
Ribblehead, Northern rail on the Leeds Carlisle line, Horton-in-Ribblesdale or Ribblehead for a walk
Updates
it's a great journey, I agree. But Whernside is the third of the "Three Peaks", not Great Whernside, which is an altogether different hill: the highest point of Wharfedale 17 Miles to the East Ribblehead.
Is this your business?