Gargoyles: The Heroes Awaken(1996)

After a magic spell in 10th century Scotland turns them to stone, a group of gargoyles that turn to flesh and blood when the sun goes down are resurrected by an opportunistic billionaire with sinister intentions.