A database; or an instance of SQL for that matter, will only run on one
server at a time - clustered or not. You can not load balance SQL databases
The benefit to clustering SQL is High Availability. Oh, and its really cool.
MVP - Windows Server - Clustering