That would look sweet! LEDs only have a certain voltage they operate in so it wouldn't fade on and off like an incadecent bulb. They'd get to a certain dim point and just turn completely off. For instance white LEDs operate between 3.2 and 3.6 volts. Any higher and it shortens the life of the LED and any lower and it won't come on. But they will definitely fade similar to waht you want and like BirBusa said, you'll need some sort of control box to get them to that. Or if there was a way to automatically vary the resistance, that would work too. I know you can do it manually with a POT, but I know you want it automatically done.
Check with Custom Dynamics and see if they sell a box or it's possible that you could get a setup like BirBusa and just use the box for yours. When do get it all hooked up, I'd love to see some vid of it!!