Assuming CS3:
1. Download the brush to a given folder (lets say Desktop/Brushes).
2. In CS3, click on the brush tool, and go to the dropdown menu with your brushes.
3. In the top right corner of that menu, you should see a triangle (arrow). Click it.
4. Click Load Brushes... and browse to where you placed your .abr file.
Enjoy