I believe the first action should be to determine what if anything is causing the alarm. Some of the models will beep in 4 beep patterns and flash the LED if it's alarming on CO, and have a continuous beep and solid LED if it's alarming for gas. A very good investment is a combustible gas detector like this:
https://www.amazon.com/Detector-PT52...01&sr=8-5&th=1
One of these will be very helpful in finding the source of any leaks and you should be able to go the exact fitting or device that's leaking. Don't just start replacing parts blindly.
Here's a handheld CO detector:
https://www.amazon.com/CT-300-Portab...1zcF9hdGY&th=1
How old is the detector in your RV? They are normally only last about 5-7 years; my experience is the lower end of that time frame.
If it's not the detector, this is a serious issue for your safety, especially the CO. It's a silent killer, but likely the most painless way to go.
As far as your water heater, if it's a tank model, they're pretty simple, no sail switches, blowers, and no standing pilot flame. They are fairly well sealed from the inside of the coach and would be somewhat difficult to leak either CO or gas into the interior. LP gas is heavier than air and I would think any leakage would find it's way to the ground before leaking into the coach. If the detector is alarming on gas and it only goes off when the burner lights, I would suspect the gas valve in the water heater. CO is a byproduct of combustion and the furnace and stove are the only other things in the RV that can produce it.
You have a potentially dangerous situation, please be diligent in finding and fixing this problem.