Hi Lenny,
A polyester resin is what I would do in this case, but it’s not something I recommend for beginners. Do you have experience with resin?
Unfortunately, resin (epoxy or polyester) is going to adhere to PVC pipe. You will either need a silicone mold the cylinder shape or somehow make your own.
This might be a good option for you — how about casting the resin into a clear plastic tubing with the rose? It would be the same idea, albeit on a larger scale, as the concept I show about using tubing to make beads in this article: https://resinobsession.com/resin-tutorials/how-to-make-your-own-resin-beads