Alexander, it sounds like you want to shoot at perhaps 15:1 on 4x5 and 30:1 on 8x10. The lenses typically used to get these magnifications have short focal lengths (12/1.9 Photar, 16/2.8 Luminar, 19/2.8 MacroNikkor) and will give you short working distances.
At these magnifications you'll need considerable extension; the magic formula is extension (more-or-less center of lens to film distance) = magnification * (1 + focal length). Depth of field will be nil with the lens wide open and stopping down will gain nothing of diffraction.
Focus stacking with a 24x36 chip digital SLR may be your best choice. Focus stacking with larger formats is physically possible but expensive and very hard to pull off. Think harder about what you really have to deliver before investing in specialized lenses for photomacrography and large format gear.