I am a registered nurse with a deep interest in Chinese Medicine. You will need to complete acupuncture school if you wish to provide acupuncture, even if you are already an RN, as it is its own licensed profession. If you don't wish to do that (it usually involves 3-4 years of full-time study leading to a master's degree), you could study acupressure and provide that care. You could do this either by virtue of your massage license/certification or by virtue of a nursing license in most states (since nurses are licensed to touch). Check with the nursing board of the state in which you would practice to be sure that this would be acceptable.
If you want to study nursing and provide primary care, you have the option of using your BS in Social Work as a means of fast-tracking to a master of science in nursing with a specialty certification. This is done via a 3-year program. You also have the option of pursuing the clinical nursing doctorate, said to be the way of the future for clinicians. Of course, the merits of fast-track programs like these are hotly debated on this board as well as elsewhere and you would have to decide how you feel about those issues. But if you are most interested in providing primary health care (which your interest in acupuncture implies), you could complete an MSN with a specialty, for example, in family nurse practice, then emphasize holistic care when you graduate.
In the meantime, let me play devil's advocate here: why are you interested in becoming a nurse? Do you really want to study Western medicine? I think that you will find many aspects of nursing school
to be pretty frustrating if you are interested in anything beyond the standard model of Western medicine. While nursing programs
may be more "holistic" in their focus (in the sense that they deal with the physical, spiritual and psychosocial aspects of each individual), only a few really offer anything regarding complementary and alternative health care practicies. You could simply decide to pursue acupuncture on its own merits. Much depends on whether you intend to work in a geographical area that is accepting of acupuncture as a primary health care profession; in some areas, being a nurse might help pay the bills.
In short, I know of no nursing programs that integrate acupuncture, since acupuncture is an entirely separate course of study. Tennessee State University has a master of science in nursing program that focuses on holistic nursing--but my understanding is that it's not yet a nurse practitioner program, despite an allusion to the same on their website. There are three other MSN programs in the country that offer a concentration in holistic nursing, and the University of Phoenix has a master of science in nursing in Integrative Medicine. I predict the number will increase given both public and professional interest in complementary health care practices. There is a program in New York state that actually offers a nurse practitioner program in holistic nursing--and I think it's the only official MSN/NP (as opposed to MSN only) program in the country. TSU is working on getting their program accepted for NP status, but as I understand it they are not there yet.
Regardless, none of these would allow you to do acupuncture--for that, you must go to acupuncture school.
Very long post, hope it helps!
RN-BC, Licensed Midwife (CA)