I have made water autotiles out of Magiscarf's revamped tiles.
They are not perfect at all, but they do have a water animation and work for the click-and-drag autotile format. They come in three colours: puddle, pond and lake - varying degrees of depth.
lolalime submitted a new resource:
Water autotiles (magiscarf) - Magiscarf's tiles set into an autotile format for RMXP.
Read more about this resource...