Why is the price of water low and the price of diamonds high?

Many factors determine price. In this case determining factors may be at least rarity and need.

Every human needs water and 70% of our planet is covered with it.

Diamonds are exceedingly rare, especially gem-quality diamonds, which represent only 20% of all diamonds mined. No human 'needs' a diamond.