When a bucket of water is used on a block under water there is a stone placement sound as if the water bucket were a block being placed, and the water emits blue particles as if the water were a block being broken. It does not effect weather or not the water bucket can be used, however.