Is orchard's a singular possessive noun?

Yes. If one was referring to the trees within a single orchard, one would write the orchard's trees.

If one was referring to many orchards, one would write the orchards' trees. It has now become a plural possessive.