Bulk water dispensing system for self-serve automated water refilling