A long-time employee opened fire at a local government building in the US state of Virginia, killing 12 people before police fatally shot him, authorities have said.