Editor: W R E N is a splendid set of high quality icons you can use to cutomize the looks of your folders.
P.S. To help clear up anyone's issues on how to use these after you download them. OSX is very fickle about trying to change icons manually, if you right click (control click) and "get info" it shows the icon in the corner. If you copy and paste an icon file onto that it's "supposed" to change it but I've found that 90% of the time it'll never work right. In regards to where the files need to be kept, I just have an "Icons" folder in my home directory that has them all in there. It doesn't really matter where they're at.
The simple answer I have for you is to install the program candybar, you can try it out for free, but the full version is $29. However it's not a bad investment if you sit at your computer as much as I do. It'll let you import any icons you want, export them in other formats if you find it necessary and the interface is all drag and drop and very simple. It'll let you replace folders, drives, system icons, Dock icons, and it even lets you apply dock skins if you want. Plus if you open the icontainer file I included you can just click "apply these icons" and they'll change immediately.