There are many options for your CB antenna. Many converted van-type RVs have fiberglass roof extensions. A magnet won't stick to that. And, with no more power out than a CB allows, a dedicated antenna beats any attempt to cmpromise any other antanna.
I have six antennas permanently mounted on my van for amateur radio and scanners. All mine, except for the large Hustler amateur radio antennna mounted on the spare tire carrier, have NMO-type mounts which makes them interchangable as needed or wanted. But, for just CB, you have the option of a hood-lip mount with the major makers. It is a little "L" bracket you can screw into the fender-side metal of the hood opening. Yuo can then route the coaxial lead into the engine compartment and through the firewall at some advantagous spot (and there are a lot if you poke around at the various sites where other stuff goes through the firewall. The antenna will then sit out over the fender and out of the way of opening the hood, but makes a sturdy mount for one of the fiberglass CB antennas that are no more than 40 inches or so tall. Then there are mirror mounts, such as many truck drivers use. I'm sure you'll find many applications and varieties as you do your research on the web. Just remember that a dedicated antenna for CB is the way to go for best performance.
Stick with a major brand to avoid the many cheap and poor performing knock-offs that are out there.