A historic 16th Century Yorkshire pub has reopened its doors after a seven-month refurbishment and significant investment.