People can relive a scene from the movies at the only pub in Britain with a waterfall in its back garden - located just two hours from York.