Hi there, saad.latif1992!
You are asking about my favorite part of the US. :O).
Santa Fe is our very favorite small US city. Yes, there definitely are some pueblos that are open to the public! This page provided by the National Park Service may be helpful in starting your research:
https://www.nps.gov/petr/planyourvisit/pueblos.htm
And these websites are even more useful:
https://www.newmexico.org/native-culture/
https://indianpueblo.org
Etiquette when visiting a pueblo:
https://indianpueblo.org/visiting-a-pueblo/
Many have ceremonies and dances that are open to the public (reference the etiquette link for rules of conduct) but other ceremonies are closed to outsiders. Some pueblos are also accessed only via tours led by tribal members. The two most commonly visited - and which we've done - are Taos Pueblo (in Taos; abt, 90 minutes from SF) and Acoma (nearer Albuquerque and abt. 2 hours from SF.) See their websites for visiting info, event calendars and entry fees:
https://taospueblo.com (also watch the video)
https://www.acomaskycity.org/page/home
These are considered the most important as they've changed little over time compared to others. Honestly, if you really want the pueblo experience, I'd make the drive to Taos. Tours of that one are optional but I'd opt for one for the background story. Tribal members who choose to reside within the old historic village (others live outside of it on pueblo lands and in more modern residences) do so without electricity or running water. You can also spend some time in town browsing the shops, have dinner, etc. before heading back to SF. I am assuming you'll have a car?
In Santa Fe I'd highly recommend the Museum of Indian Arts & Culture and Wheelwright Museum of the American Indian. Pecos National Historic Park may also be a good one as it's not far from SF - only 25 miles - and has a well-explained Ancestral Sites Trail walking route through the ruins of a pueblo and an enormous mission church. We just did that one this past spring and throught it was well worth the visit. LOL, I took way too many pictures!
https://www.nps.gov/peco/index.htm
Just a start? i'll noodle for more ideas. Oh, and read up on the Pueblo Revolt of 1680: it's an important chapter in NM history.