A shooting at a church in Wayne, Michigan resulted in the suspected gunman being killed by a security guard, according to local police.