I've got a UV mapping tutorial at my website. As for making the texture itself, it's just a matter of using Photoshop, really... don't know of any tutorials regarding that... heh heh