The answer to this question would depend on who you perceive as the protagonist.  Miss Emily seems like the obvious one although many argue the narrator (the collective town) is the protagonist.  If Miss Emily is the protagonist, then the mood of the protagonist is mysterious, proud, and bizarre - matching the character of Emily.  If you argue the protagonist is the townspeople, then the mood becomes curious, whimsically humorous, and sympathetic.

The mood in this story is one of quiet humor laced with sympathy for Miss Emily's plight.  He seems a little sad or disappointed that the town didn't do more for Miss Emily, the last of the Pre-Civil War remnants and town icon, so that she wouldn't have ended up the way she did.

What mood does the story "A Rose for Emily" evoke?

The mood in Williams Faulkner’s short story “A Rose for Emily” has always struck me as a sort grim. As readers, we recognize that Emily’s relationship with her father is dysfunctional. This is clear in the description of how her father would chase suitors away. He’s framed in the doorway, and Emily is in the background. Her response to his death is not normal either. She refuses to let them take the body away, and then she becomes a recluse. Emerging a long time later, and her appearance has changed drastically. Was she abused by her father, we don’t know, but there could be a good psychological argument for it. In addition, it is clear to the reader that Homer Baron won’t be settling down. He, probably, uses Emily for his own purposes before attempting to leave her. No doubt he took everything the woman had to offer, including her good name, before rejecting her.

Enotes has some good information at the following link.

http://www.enotes.com/rose-emily