Borescope, Light Pipe, carefully placed first surface mirror, any/all of these effects will help you to realize your goal. Focus stacking, as Q.G. pointed out only helps with the DOF issue, and should be the last consideration after point of view and realization of that point of view.