Is the word moody a noun?

No, the Word moody is an an adjective. The noun form is moodiness.

The exception is when Moody is a person's name, then it is a noun.