A gunman opened fire during a service at a suburban Detroit church on Sunday, wounding at least one person before a security guard killed him, police said.