Hi Matthew
A few points here:
1. The CSC module runs a version of Trend Micros engine, and doesn't support Websense.
2. The ASA can, via a service policy, relay traffic through an external Websense server which would need to be built as a separate server.
3. In transparent mode, the ASA only supports two interfaces which are effectively paired together as a layer 2 team (in and out). I think this means that you are going to struggle with your set up as you need two sets of two interfaces to keep your networks separate.
4. The only thing I could think of to assist with (3) would be to run 2 x contexts on the ASA. This would allow you to run 2 x transparent firewalls however from memory you need a 5510 to run contexts,
Barry