The above assessment means your fuel consumption numbers are a bit off.
Most in universe fuels will be alcohol based, either ethanol or methanol. Biodiesel has better energy density (about equal to regular diesel fuel) but would require animal fat or much larger volumes of crops for vegetable oil. For steam power you could use wood but at 2/3 efficiency compared to alcohol.
For simplicity let us create some new materials
Fuel 2lb common
High quality fuel 2lb uncommon
Gasoline 2lb (very) rare
The use of scenes does not translate well into fuel use. You could drive for 6 hours (60 miles) or maybe only 3 miles in a scene. Distance would be better. our materials list would look like this.
Fuel 2lb common 2 miles
High quality fuel 2lb uncommon 3 miles
Gasoline/ diesel 2lb (very) rare 3 miles
wood 2lb common 1 mile
I agree that water would be required for steam transport. In fact it would lose water at a fair rate (leaks etc). A car sized steam plant would need at least 20L of water and lose about 1 unit (.5L ?) per hour. Steam plants would be too heavy for air transport, other than airships. However using dirty water would not necessarily expose crew/ passengers to radiation. Instead it would build up in the boiler. For every 10 units of dirty water used the boiler becomes a +1CD radiation source. This can be removed by purging the system, which takes 1/2 the boilers capacity (20 units to purge) and leaves a radiation source where dumped.