There are several programs and plugins which are designed to create normals.  And there are several tutorials available on the web detailing how to maximize the effects.  Free plugins exist for both Phototshop and GIMP, IIRC NVIDIA offers the free plugin for Photoshop, GIMP has it's own.