Is a Zero Maintenance Water System Real?

Can a zero maintenance water system really exist? Understand what it means, where it works, and where filters, salt or power still enter the picture.