In the sophisticated Mid-Beach neighborhood, US Travel Editor Ted Thornhill checks in to a location with chic vibes and a stunning outlook