The secret corner of rural Yorkshire that's perfect for stay