You would most likely need a 3D app like Blender which is free or 3D studio max, Maya etc to set up some 3D text and then you light it and texture it to suite. You can get away with photoshops built in 2D lighting for stuff including font lettering but I think the 3D route gives you much more control.

Do text is 3D is usually not too hard since the apps normally have a vector font (like true type TTF) to 3D import. Then you can bend or extrude them a bit then its just a case of texturing and lighting. The texturing can usually come from a 3rd party texture house like CGTextures (check out the bottom of http://www.cgtextures.com/textures.php?t=browse&q=579) and then lighting is usually not too hard either.