After years of riverside memories and famous drop-ins, the family behind the laid-back 1887-built pub – complete with its own mooring dock on the Tweed – are ready to pass the pint glass.