A historic Knaresborough pub dating back to the 17th century has reopened following a £250,000 refurbishment.