There are currently two active releases available:
The latest release of Apache Cassandra is 2.2.2 (released on 2015-10-05). If you're just starting out and not yet in production, download this one.
The most stable release of Apache Cassandra is 2.1.10 (released on 2015-10-05). If you are in production or planning to be soon, download this one.
The current major version of the Cassandra Query Language is CQL version 3. The CQL3 documentation for the current version of Cassandra (2.0) is available here. The documentation for CQL3 in Cassandra 1.2 is here.
New users to Cassandra should be sure to check out the Getting Started guide.
The latest development release is 3.0.0-rc1 (released on 2015-09-21).
The lastest release on the 2.0 branch is 2.0.17 (released on 2015-09-21).
Older (unsupported) versions of Cassandra are archived here.
The Cassandra source code is available to download:
git clone http://git-wip-us.apache.org/repos/asf/cassandra.git
Bleeding edge development snapshots of Cassandra are available from Jenkins continuous integration: trunk