Based on

Movies like Gargoyles the Movie: 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.