If you are just starting out I'd recommend Blender. Basically 3D CAD programs apply a texture to a mesh by mapping. Just use your photos as texture files.
Have a look at my recent vans they have a photo in a .tga texture file, placed there by Paintshop pro, but GIMP or Paint.net will work fine and are free.
Cheerio John