Vacant Ripon pub under new ownership