Aqua Hot & Residential vs. non-R - seeking Info, Dinette too

Looking at upgrades, maybe even a new coach... investigating has turned up a few questions, like, what is Aqua Hot? Why would I consider it? What does it cost. Is it standard on some, after-market on ...