Does your tileset include tiles for the animation? I can’t see the whole tileset in your screenshots, but it looks like there’s only one frame available for each of the waterfall tiles, so there’s nothing to animate with.
You could animate using the existing tiles (left edge animation, middle animation, right edge animation, each cycling using the three available tiles), but since those tiles don’t look made for animation, I don’t think it’ll look good.
You might look into implementing a texture scrolling shader to move the “wave” lightened area of the waterfall down and have it wrap around. This would create a smooth looking effect.