Why don't you just make a "water meets sand" tile then?
A picture would help, but unless I'm mistaken this would do the trick for the problem. Except, you'd need to lay out the autotile over the entire water area (layer 1), and then put your new sand/water tile on top (second layer). (There are 3 layers, right?)