I don't think I would want to take a CNG truck to Yellowstone NP and then try to find fuel along the way. There are not that many CNG fuel stops near a National Park. It might be fine if you only go limited distance, and always have a place to refill.
I drove a CNG Honda car, the problem it needed fuel every 90 miles. So you drive like 10 miles out of town, then notice that the last person driving it left only 1/2 tank in the car, and your trip might be 45 miles. You have to return to the nearest fuel station, fill it then be able to drive to your meeting or conference.
I know someone who drove a CNG combo truck from Long Beach CA to a confrence in Reno NV. Yes he made it on CNG, he was trying to say "I made it" and stopped in Bakersfield and Fresno, and Sacramento for CNG refills. Had all kinds of adapters, and those cities did not bill him for the fuel. (Billing for 10 - 12 gallons of $1.20 fuel would have been a headache) Anyway his truck would also run on the factory 19 gasoline tank too.
If you have your heart set on both a 3/4 ton and fifth wheel with a 1,500 - 2,000 pound hitch weight, probably should also stick to the lighter gas engine trucks - especially if you will buy used. The newest trucks have much higher GVWR, so might have plenty of cargo capacity, however the 2004 and earlier trucks had low cargo ratings, and the 2,000 pound potential hitch weight can use up more cargo rating than most 3/4 ton trucks come with.
Lets say the truck has a 8,800 pound GVWR and at the curb it is 7,000 pounds, crewcab with lots of options on it. You can only carry 1,800 pounds of people, cargo, and other things in that truck. Better to look for a 2005 and later F-350 with it's more generous 11,000 or 11,500 pound GVWR, and they can carry 4,000 pounds in the F-350 version or 3,000 pounds (about) in the 3/4 ton F-250 version.
What to stay away from?
Lets just say a lot of F-250 and F-350 owners of the 6 Liter diesel and 6.4L diesel sold them cheap to get rid of them. Potential problems are that the oil cooler and exhaust recirculation cooler leak around 100,000 - 120,000 miles. If replaced, and they never leaked, no problem. However one leak means a potential $15,000 engine replacement. This is because coolant will leak into the engine and destroy it.
THe GMC 6.6L engine has proven very reliable. The 5.9L Cummings found in the Dodge trucks has been much more reliable than the truck it is mounted in. Ford's new 6.7L found in the 2011 and later trucks is also a great diesel engine, and very quiet as well. It also comes with the higher GVWR, and high cargo ratings.
Gas engines? Well the 5.4L found in the F-250 and F-350 has 300 HP, should perform as well as your toyota does. The V10 6.8L is a little more power, and is used in 24,000 pound motorhomes, 26,000 pound GVWR F-650 trucks, even with CNG in the larger dump trucks. It is rated at some 360 HP or a little more. But fuel mileage will be less than the F-350 with a 5.4L engine.
I have towed a 7,000 pound generator with a 1994 F-250 and 351" engine. This was factory rated at only 175 - 200 HP, so the 5.4L has much more power than I had, yet still the truck did fine.
Fred.