No, LED street lights don’t make a noise because their principle to emit light is different from that of traditional street lights. Traditional street lights make a noise because they need a high voltage to stimulate the inert gas to generate light. The way to provide high voltage is through the ballast, and the ballast will make a noise while working. LED street lights apply a totally different method to produce light, which is the recombination of free electrons and electron holes.
More reading: What Is LED Street Light?