Ripon pub set to unveil new £170,000 renovations