That’s not going to be simple. At first, when I read your post, I thought, create a cylinder and skin it. No problem. Adobe dimension, or even 3D in Photoshop. For the rest, I am guessing you my need one of the Maya / cinema 4d type programs. Not sure if the goes beyond photoshop’s 3D capabilities. I don’t do enough of it to know – perhaps someone else here has more experience with it.
Another option is Blender, which is open source free software and pretty powerful. I did some work with it quite a few years ago, in its early incarnations and it was pretty good. Now, I believe, it a much more sophisticated beast.
However, if you have never done any 3D Ray-traced work, you are in for a pretty steep learning curve. You have to change your head a bit. We spend most of our time adapting a 3D world on to a flat, 2d plane. Working in 3D can get confusing at first. You have to think, quite literally, outside the box. It’s very easy to lose things behind the back of your head. That’s quite a project to start on. It may be better to find someone to help you out. Or at least start with a simple shape, lighting, rotating, positioning and image mapping that to get used to how It all works.