You get a bucket when using a filled one on a cauldron.

When putting a bucket of water or lava in a cauldron, in creative, you get an empty bucket.

You can tell that I'm getting an extra bucket by the fact that the bucket in the third inventory slot is larger than the water bucket.