From what I know, if you just want to do clinical work, prestige isn't important. So if you want to go into the field and just work as a social worker, then any accredited MSW program will be fine.
Prestigious schools are important if you want to go into politics or if you plan to do a phD in the future. Otherwise, it doesn't matter.
More importantly though, don't go to a school where you have to shell out a lot of money, regardless of prestige. If you're paying 100k to get an MSW, that's just stupid considering how little MSWs make.