A substantial 17th-century pub that is well situated between Hadrian's Wall and the North Pennines is up for sale.