A Bradford pub built on a historic site is to undergo a six-figure refurbishment.