Oh, you saw one of those! They're quite practical, aren't they? That specific setup is typically called a smoking station or a sand urn receptacle. The sand bucket on top is for safely extinguishing cigarettes before disposing of the butts in the main bin below.
You'll most commonly find them in locations where smoking is permitted but needs to be managed carefully to prevent fire hazards. Think beaches, public parks (especially near picnic areas or benches), outside the entrances of hotels, restaurants, office buildings, and in designated smoking areas of commercial complexes.
If you're looking to purchase one for your own property or business, you won't usually find them at regular home improvement stores. Your best bet is to search online for "commercial outdoor smoking receptacles," "sand urns," or "beach ash trash cans." Several companies specialize in manufacturing durable, weather-resistant street furniture like this for municipalities and businesses. They are often made of galvanized steel or other robust materials to withstand outdoor use. I hope this helps you track one down!