The 17th century pub enjoys one of the best waterfront locations in the country