Degree Requirements for Teaching at Community College or University Level???

Most community colleges require a Master's (minimum) for lecture faculty positions, although they may use some BSN-prepared people as clinical instructors.

Colleges and universities with BSN programs require a minimum of a Master's; most prefer a doctorate. Some require doctorates and won't consider Master's-prepared people (or use them only as clinical instructors).

As to whether or not you could lecture without also teaching clinical, that would depend on several things, and there isn't a clear "yes/no" answer to that. Yes, it is possible, but it would depend on things like the policies/preferences of the individual school, how much seniority you had within the department, who else was available to teach the clinical courses, etc. You might well be able to "work your way up" over time to not having to teach clinical. I doubt there are any schools of nursing out there that would offer you a position teaching OB nursing but guarantee/promise you up front that you would never have to teach clinical ...