No official “water fairy” category exists. The term loosely describes fairies associated with water. Based on wing themes/behavior:
Books rarely define elemental roles explicitly. For deeper lore, check the Pixie Hollow Wiki or re‑read with attention to water interactions.