Hi, gmbrd. For general lighting purposes I use a mixture of lighting. In my shop lights, I have GE Chroma 50's (these are the daylight tubes already mentioned; they're available in other brands also), but I also have small 50-watt incandescent spots in track lights for highlighting certain areas.
When I want to take pictures, I simply turn off the incandescent spots; the daylight tubes are color balanced for daylight films, so there's no weird green color shifts. (Recently, however, I have been photographing my layout with my new digital camera. I leave the white balance set to "auto" and it has no trouble handling the mixture of incandescent spots and florescent tubes.)
If you plan to have your shop lights on for long periods of time, I recommend you follow Vic's advice about using UV filters on the tubes.