It depends on the style you use. For a (pseudo)realistic style, a simple use of bevel and emboss in photoshop works quite well for me.