You might find this post interesting: https://beccaelizabeth.dreamwidth.org/3119242.html

It's a discussion of how an easy purify water spell changes a society. All of beccaelizabeth's posts under the 'magic' tag or the 'gurps' tag might be of interest, too.