The new Yamaha mixer (assuming you mean the MG06-3rd generation) is sweet. I have the 16 channel, 2nd generation version and it’s a great performer. Good sound quality, great mic preamps. There is an X-version with built-in effects, but that is not really relevant to DJs, unless you intend to use it karaoke or live singers or something as well.
It does not take RCA though, but a simple set of RCA to (TR) Jacks will take care of that. It’s even got phantom power if you feel like using a condenser microphone :-).
A few alternatives in the same global price range are:
* Mackie 402-VLZ4
* Mackie Mix 8 (with an extra AUX output, which you could turn into your booth output)
* RCF L-Pad6
Since you’ll be going active speakers and using a good, small PA mixer with proper XLR balanced outputs, all you need are some proper XLR cables. I personally stay away from the low end stuff, but I find the really expensive ones are only really sensible for actual recording studio work. I use ProCab a lot (they have three price ranges per cable usually), but I know they are primarily a European supplier.
There is no need for gold-plated plugs or anything. Be sure to get cables with Neutrik connectors, they are the defacto industry standard and in my experience the best available.