Gargoyles the Movie: The Heroes Awaken(1995)

Overview:

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.