While LEDs do produce some waste heat, efficient ones convert 50%+ of the input power to visible light, so it's less than you might think (compare to ~10% for incandescents, iirc). The bulb I have doesn't have a perceptible effect on my room temperature (although I guess it probably does cause the thermostat to turn on a tiny bit less often).