When you revive the fossil at the Pokémon Lab in Veilstone City, you will obtain a Cranidos.
Cranidos is a Rock-type Pokémon with a powerful headbutt attack and a sturdy defensive stat.