Gargoyles The Heroes Awaken (1995)

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