Yes, you should be able to install this into a "Custom Application (listening on port)" application. First, create a new "Custom Application (listening on port)" Application through the Control Panel. Then install Apache 2 from source into the new application directory created under ~/webapps/. You would compile this something like:
You can then compile and install mod_scgi into this new local Apache instance. When creating a Custom Application (listening on port), the Control Panel will assign a local port for use with the application. You will then want to configure this new Apache instance (in httpd.conf) to use mod_scgi with this port.
Edit: This is also semi-possible using a "mod_wsgi" application via the control panel. However, this installer does not include apxs, which is used to build modules against an Apache instance. If you are able to compile the .so module separately (or acquire it from someone), this is another possibility.