Is it possible to make water similar to Terraria's in Godot? How?

Can I make a standard TileMap do this? Or do I have to create a custom plugin node?

@Zylann Your example is fantastic, is it possible to make the water interact with RigidBody2Ds?