I'm really quite scared now - I swear I went to that place (or one that looks very similar), and took almost the exact same photo a few years ago. Disturbing!
It was close to "The Red Lion Inn", Burnsall, near Skipton. There's a river, Wharfe, if I remember correctly. That would be funny if that's the same place.