If you're using a somewhat new (less than 5 years old) digital camera, you can pretty much use any light source you want, and the digital camera should do a decent job of balancing to it (you may need to play around some if the camera has color balance settings) but I would go with whatever is either cheap or you already have, but stick to a single type of light. The Clamp Aluminum Dish worklights are nice, cheap and convenient, and you can either put standard lightbulbs or daylight balanced bulbs in them, or even the compact florescent bulbs, but again ONLY ONE TYPE OF LIGHT!!!! If you go with standard incandescents, you can mix wattages, but I would stick with a single brand, as there can be some variation in the color balance of them.
Cheap shop florescent fixtures or aquarium lights can work well too, but you need to be very careful that the bulbs in them are the same type, especially with the aquarium ones, as they sell some VERY strange bulbs for aquariums.
If you want to have a TON of light, and like to keep warm while you're shooting (hey, winter is coming up...) you can even use the 500W halogen work lights from Home Depot. They're cheap (I've seen them as low as $5, sometimes it costs more to replace the bulb than buy a new light) absurdly bright, and they'll warm your shop up in no time. Plus you can use them at in December to light up your Christmas decorations...