From what I’ve seen, honors colleges/programs are more popular at public schools than private schools. There are prestigious public schools that have them (e.g. the University of Michigan), and less-prestigious private schools that don’t.
Also, some universities offer honors in certain majors without having a university-wide honors college/program.