Seventy percent of millionaire households used some sort of financial adviser, and the average length of that relationship spanned 10 years, the survey found.