In this sentence, the correct word to use is "effect." The sentence should read: "The new law will have a significant effect on our community."
"Effect" is a noun that refers to the result or outcome of something, while "affect" is usually used as a verb meaning to influence something.