Alandis2015 got the answer and it is... Cloudtail

I'm part of a prophecy and will be destroyed by water
Had three kits
I have blue eyes
And I have a sister of Snow
Who am I?