Water spots are a result of mineral deposits left on the surface after the water has evaporated. These minerals can come from within the water (hard water) or from particles already on the surface of your vehicle if dirty (ie pollen, dust, etc). Most rain water, aside from acid rain, will not leave spots on its own... at least that has been my experience. The exception is when you have particles already on your paint, as I already mentioned, that will stick to the water droplets forming as it rains and remain after the water evaporates. Municipal water sources... tap water from hoses, sprinklers, etc. is typically quite hard and therefore will certainly leave spots and should never be allowed to dry on your vehicle.
Regardless of the LSP that is applied to your vehicle, if these mineral deposits are left on the surface, you will have stubborn water spots. If left for too long, you may experience water spot etchings.
Long story short - if you're concerned about water spots, wash your car after it rains.
If your spots have not etched, a good wash with some warm water may be all it takes to remove them. Otherwise you will need to use a water spot remover like CarPro Spotless. If they have etched, then break out the abrasives. Polish, Compound, or in the most severe cases, wet sanding will remove water spot etchings.