Crystallographic water sites from a theoretical perspective