My barrels do pretty much what OP is asking for. Ex Nihilo
If you want to completely automate the process, use a macerator or pulverizer to turn sand into dust. Set up a barrel so that it's getting a supply of water from a pump or an aqueous accumlator. Pipe the dust blocks into the top of the...