Is the word cacti's a a plural possessive noun or a singular possessive noun?

It is a plural possessive noun.

A singular possessive noun. A singular possessive noun is when you add an apostrophe and s when the original doesn't have an "s" while a plural possessive noun ends only with an apostrophe because the original has an "s".