The Apogee Duet is an Audio Interface only, for recording and playing sound, to professional standards. It turns any modern Mac into a hi-end two track digital sound recorder. But your piano keyboard cannot do anything with it, other then record the Audio output from it.
You can use your USB keyboard (which make & type is it?) to play Logics' software instruments. If the piano keyboard only has MIDI connectors, you either need a MIDI-interface for that, or for the USB keyboard to have a *MIDI in* port.
If you need both an Audio and a MIDI-interface, there are cheaper models that'll do both. The best device to use, as you put it, really depends very much on what you want to do with it, and of course what your budget is.