If you want the cpu heatsink fan to blow air from the bottom to the top, then rotate the heatsink clockwise 90 degrees and then install the heatsink retention bracket. This should work with cpu heatsinks that have a universal retention bracket that can be used with just about any cpu socket.
The first one that comes to mind that might work is the Coolermaster Hyper 212+. It is an excellent heatsink and a very good value. Here is a link to newegg where you can watch an installation video:http://www.newegg.com/Product/Product.aspx?Item=N82E16835103065
EDIT - I just watched the video and a few more over at youtube.com. I'm not sure theheatsink can be rotated 90 degrees. There's also another problem. When rotated 90 degrees it appears as if the heatsink will interfere with the two memory slots closest to the cpu.