Water is extremely unusual in a number of ways! Due to the actual shape of a water molecule, it's also unusually polar, allowing it to dissolve just about everything we need to live. And it has one of the strongest surface tensions of common liquids.

And unlike most other substances, the frozen form is less dense than the liquid (as you noted), meaning ice floats! I don't know a single other substance that behaves that way.