Most older street lights use High Pressure Sodium Bulbs that require a transformer to produce the voltage to light it up.
Now newer street lights are typically going to LED street lights so they would use regular LED light bulbs that are made for the outdoors.
Mercury Vapor bulbs are another type of bulb used in street lights besides the High Pressure Sodium Bulbs and now the newer LED Bulbs.