Is it possible to make the sprite superimpose on the stone texture ?

Hello everyone
Is it possible to make the sprite (game character) superimpose on the stone texture, take into account the relief, etc?
I sketched in Photoshop what it might look like.