Yes, there are tearooms — but lonely stone villages, battered bracken moors and designer digs, too. Anthony Peregrine gets a shock in England’s Yorkshire Dales