Question about a good textures / terrain shader

Hello sorry if this sounds silly but I don't really know what is this called. I looking for a shader that will work will normal textures and terrain and I was wondering what will be the best to use.

The type of shader I will looking for is something that lets say you have a stone brick floor and in some games you have sand build up in-between the bricks and or water/blood flowing through brick.

Sorry if i'm not making much scenes on what I'm trying to say I don't know what the name is to this effect and sorry if i wastes your time.

Have a great day and thank you for reading my post.