"Sex and the City" star is appearing at Manhattan Theatre Club, where she played a lovable pup in A.R. Gurney's Sylvia