Aquabike is a new bike/swim only race that some USA Triathlon is trying to start for people that can't run. Unfortunately, they are few and far between right now.

Vineman offers one:
http://www.vineman.com/index_main.php3?l=aqua

Of course, there are a lot more races that offer relays.