A lot of schools are phasing out their clinical masters programs in favor of either a specific substance abuse concentration or trying to build up a phd program. Ok, I haven't looked at programs since last year, but that seemed to be the trend at that time. I know of two NC schools doing that currently.
Also, it's my understanding that if any school anywhere really wants you, they will fund you to attend their program. Even in social work (typically rarely funded), myself and a handful of classmates were able to secure aid from assistanceships, department scholarships, and an award from the school. I think it pretty much added up to the cost of tuition for the program.
I remember many years ago, when I first applied, I had a friend who applied to only masters' programs. She was a GREAT student who would have been an excellent doctoral candidate but didn't want to commit to anything for 5-7 years at that time... she received funding offers from every school where she applied even though many stated that they didn't fund master's students.
Good luck with your search. I'd go directly to department secretaries and ask about prior arrangements. They usually know everything going on in the administrative areas!