How often should it produce water?

To avoid stagnation issues, the RO system should be used once a week.  It is best to run it once or twice for several hours rather than having it turn on 10x per day.  The latter method wears out the membrane and depletes DI resin more quickly. Plan ahead and store RO/DI water for top off needs in sealed jugs.