The answer is in your question.
Use a 3D program. Take your time to model it, unwrap it and to prepare the lighting and camera angles to match a given scene.
I would use Blender (blender.org) because it has everything you need, again, modeling, texture unwrapping, photorealistic render, you can even track a video to match it, and it's free.
Just take a ...