Why don't you boil the water beforehand? Boiling hard water will break down and precipitate the minerals that are in it leaving the water softer. Maybe it will be more effective.
I am currently researching options on this very topic.
Best bet, in my opinion, is to get a deionizer. Griot’s garage has a couple good option but you can find deionizers that hook to a garden hose all over the internet.
Aren’t you worried about the hood getting a permanent shadow from the decal?
Our water is very hard where we live as well and it is a big pain, and if you don't have hard water, you don't know what a pain it is. Your water spots are almost certainly caused by your hard water and it drying on the surface before you dry it off. If you wash your truck in the sun, you are almost certainly going to get water spots regardless of how quick you are to dry the surface. If you can wash the truck in the shade during the cooler part of the day, it will be much easier to keep the water spots off. Using large, micro fiber drying towels will help too.
Watching many detailing videos, and trying many different products, by far the biggest difference is avoiding the sun, washing during the coolest part of the day, and drying as quickly as possible.
To solve this problem, you can boil the water beforehand. Hard water contains minerals that cause water spots and the lessened efficacy of soap so boiling hard water will break down and precipitate the minerals that are in it leaving the water softer. Make sure to wait for the water to become room temperature before you use it then proceed to wash your car as usual.
Second, I have a DI Rinse deionizer. I try to keep the entire truck wet at all times that way there is less chance to get water spots. I only use the deionizer when I’m in the final stages of washing that way I don’t have to recharge it sooner. https://dirinse.com/product/d-i-rinse-pro-50-unit/