Check your distros repositories for the Driver..
default@itg-debian:~$ apt-cache search Prism2
hostap-modules-2.4.27-2-686 - Host AP driver for Intersil Prism2/2.5/3 (kernel 2.4.27-2-686)
hostap-modules-2.6.8-3-686 - Host AP driver for Intersil Prism2/2.5/3 (kernel 2.6.8-3-686)
hostap-modules-2.6.8-3-686-smp - Host AP driver for Intersil Prism2/2.5/3 (kernel 2.6.8-3-686-smp)
hostap-source - Host AP driver for Intersil Prism2/2.5/3
hostap-utils - Utility programs for Host AP driver for Intersil Prism2/2.5/3
hostapd - user space IEEE 802.11 AP and IEEE 802.1X/WPA/WPA2/EAP Authenticator
So it's available in Debian or any debian based distro, such as Ubuntu, Kubuntu, Xandros, Knoppix, etc.. but is probably not loaded by default.
One Live CD that MAY have it available by default would be Auditor, since it is designed to work with wireless from a Live CD. http://www.remote-exploit.org/index.php/Auditor_main