New Harrogate pub opens tomorrow