Yes, any MIDI source for those CCs will work as an additional mod source - so you've got Foot (CC#4), Expression (CC#11), Mod wheel (CC #1), and Breath (CC#2) as potentially useful inputs. Some of these even have fixed mod slots so you don't take up any of the 8 user-definable slots for your first routing.
There exist MIDI foot pedals too, which you might look into, and controllers which can accept one or more standard foot pedals and translate them to CCs. There are many options. The Prophet 12 supports 2 continuously variable foot pedals, but the Rev2 only supports 1, so the only way for you to get additional modulation into the Rev2 is via MIDI. Of course that can be from a sequencer, a DAW, or whatever source of CC you want, really. No need to limit yourself to foot pedals unless that's the specific interface you desire.
But CC modulation isn't really directly related to foot pedals on the Rev2, except that they can be a source of the CC value in some cases, with external hardware.