A much-loved historic Harrogate pub has announced it is to close.