This is actually a very popular asset on the unity asset store, mainly because of what it offers and it's price tag: free! Its a terrain shader that can really enhance your visuals and help you achive something like this when it comes to making terrains:
And yes it does come with an example scene, that's actually set up pretty niceley! Check it out! you can use this for many purposes!
[You must be registered and logged in to see this link.]