Water systems with under-counter mounting