I had the same question a few months ago and spent a good bit of time at the local bookstores looking through their Lighting books, generally all in the Photography or Art sections.  I ended up buying "Light - Science & Magic, An Introduction to Photographic Lighting" (ref http://www.borders.com/online/store/TitleDetail?sku=0240808193 ) and have been very pleased with it.

It includes very practical explanations of various lighting situations, along with setup diagrams (positions of camera, lights, subjects) and excellent color photos showing the results.  The authors include advice both on techniques that work and what to avoid, clearly explaining the rationale for a lighting situation.

Best of all, I found that their presentation of the "science and magic" of real-world photographic lighting is directly applicable to lighting in 3D computer art.  Unlike many other books in this category, this one did not "waste" much time on photographic equipment usage and specifications (e.g. exposure meters, strobe lights), but concentrated on the placement of the lights themselves and the resulting artistic effects.