The correct word to use in this sentence is "effect."
So the completed sentence would be: "The new law will have a significant effect on our community."
"Effect" is a noun meaning a change that has occurred, while "affect" is a verb meaning to influence something.