If you're set on using 'real' light guns your options are:
ACT Labs usb guns - apparently very accurate, but very rare and expensive. From what I've read they work in all OS's.
Optigun/USB2Gun board - these are used to interface with the real arcade guns, they can be found but are also pretty expensive. I'm not sure if these work on modern os, they might?
Guncon2 USB Light guns for PS2 - these are plentiful and cheap but will only currently work in a 32bit OS as P.H.U. mentioned. The namco guncon2's will *sort of* work but they have the rolling-x issue where the cursor can wrap to the other side of the screen. Wingun has a correction option for this that makes namco guns close to usable but on occasion, moving the gun offscreen and then back onscreen the calibration will be off for a shot. 3rd party/other brand lightguns do not have this issue at all so I recommend going for a 3rd party guncon2 if you're interested. Driver development for these kind of died off but what does exist, works well in Windows XP.
I personally use 3rd party Guncon2's in XP. I have the yellow composite cord spliced into the sync wire output from a JPAC video amplifier to use my system with a real arcade monitor. (I soldered a female rca connector in-line with the sync wire to accomplish this.) If you have a video card with composite tv output that's probably the easiest way to try it, plugging that into the gun and the gun into a crt tv.
I have a complicated project in mind that will hopefully get Guncon2's working 100% in x64 os (using a driver originally for the Topgun IR gun) but it requires a small custom circuit that I'm still working out. I'll be posting about that when I have better results.