The agreement introduces one of Hilton’s internationally recognized hotel brands to a waterfront destination