A man opened fire outside a Kentucky church, killing two and injuring two others, before being fatally shot by police.