If you want fully integrated, then SubZero is the way to go. Use a filter pitcher inside the fridge than you fill up manually or get a chilled water dispenser for a bar sink. Be aware that any of the water dispensers, instant hots, ice makers, et al are energy hogs.

The SZ FD is a built in model and will have to be installed as a flush inset installation. The FD is not one of their fully integrated models. I'm okay with that.