I believe it would require no programming:
- add a Wooden Bucket recipe (cost: 1 log, produces: Wooden Bucket, crafter: Carpenter)
- add a Water Bucket recipe (cost: Wooden Bucket, produces: Water Bucket, workshop: Well)
- make all recipes which utilise Water Bucket return Wooden Bucket (multiple
"item"entries can be added in a"produces"table - adding a Wooden Bucket as an additional product would mean the water is used but the bucket is returned, see: Is crafting multiple items in one recipe possible?)
For Rayya’s Children Wooden Bucket would be overridden by Clay Ewer.
One could then queue the Water Bucket recipe and stop worrying about the water supply. The question is which crafter should get the Water Bucket recipe, because it cannot be assigned to Workers. Another problem is this way Hearthlings would get experience just by fetching water from the well…