A Connecticut family sought out Dan Mazzarini of BHDM Design to help create a chic but comfortable waterfront retreat