For the water drop picture, I used my 8.2mp Canon Rebel EOS (I think its EOS) with a 28-75mm wide angle lens with a macro lens attachment. It wasn't actually a macro lens, the things I have are pretty much magnifying glasses that I can attach to my lens (since I'm too poor right now to actually buy a macro lens). They seem to work pretty well, although a real macro lens would of course be better.
Basically to get that shot, I filled my bathroom sink with some water, added some black dye to the water, and let the faucet slowly drip. I probably took about 75-100 pictures to get that one. It's pretty difficult to shoot the droplets hitting the water at the exact right moment. So basically, it's hit or miss.
Here are a few more of my pictures...



