A sight glass is fairly simple device. Fluid enters a the bottom, top is vented to the same location as the fluid. the fluid seeks it's own level, therefor the level you see on the tube matches what is inside what you are checking for.
In order for it to work the biggest thig to remember is the venting of the top of the sight glass. Since the transmission case is not presurized, as long as the top is open to the atmoshpere it should work. But being used in a vehicle, particurally an offroad vehicle, you can't leave the top open or it will spill and/or take in cantamination. So it must be looped back into the case.
What you will have should look like the Atlas sight tube (the pictures didn't come across on my computer but I know what they look like). You will need the lower tap below the fluid line, pan will be fine. The upper fitting only has 3 choices as you are not willing drill the case (good idea).
1) tie it back into the vent on the top of the transmission
2) tie it into the dipstick tube (least liked by me as you have to still deal with the dipstick, rely on the dipstick not sealing tightly in order to vent and the dipstick tube still enters below the fluid level so it still isn't really vented to the same as inside the transmission as it would in #1)
3) place the vent high enough that you can't slosh the fluid out. Make sure the standard trans vent is still venting correctly or else pressure differential will alter the sight glass readings.
Also pick materials carefully. The cheap vinyl hose that you see working for an Atlas is no match for the heat of a warmed up transmission. Also note that most clear plastic tubing will tend to stain from the dyes in transmission fluid, especially hot fluid. There are some industrial sight glasses that may be able to be adapted.