Located on Pier 67, this upscale waterfront hotel, whose famous past guests include The Beatles and Led Zeppelin