The best bulbs to use inside are ones having 5500-6500 kelvins using 45 watts, which translates to daylight. Frosted ones are great because of less shadows.
A digital SLR is the best way as you can use different lens. A good macro lens 60mm, 90mm, 100mm are best. A tripod is usually a must unless the lens has VR (vibration reduction), but the tripod is still better.
I use the cheap clamp on light fixtures with the aluminum reflector that you can pick up at hardware stores, Lowes, Home Depot, etc., with the above mentioned lamps.
If you really get into it, soft boxes with five of those lamps in it that can be independently turned on for various lighting.
