Here are some ideas of where to apply if you want semi-prestigious.
https://www.usnews.com/best-graduate-schools/top-health-schools/social-work-rankings?_sort=rank-asc
You can get a decent job in social work without going to a tippy top undergrad, by the way.