I would like to make a map where it's possible to zoom in on a location to get more detail. A lot like google maps (although the transition wouldnt have to be as seamless), e.g. the coastline gets more rugged, smaller road become visible building start to take shape from the city mass.

I thought about doing this by using a Vector program, where I make the world map and on subsequent layers maps with higher resolution and more detail, which I could then make visible according to the factor of zoom.
But neither do I know how to properly do map scaling, nor do I know if my idea even works haow I imagine it.

Are there programs that I could use to automate this process? Or should I just make the maps to print and be done with it?