In this context, the correct word would be "affect." So the completed sentence would read: "His cheerful attitude can really affect those around him."
"Affect" is a verb that means to have an influence on something, while "effect" is a noun that refers to the result of a change or influence.