If you're looking for a faucet mounted filter, I recommend the
Culligan one
. I'm using it in my apartment where it replaced a Brita filter that broke one me. The Culligan is a bit more compact and has metal fittings for connecting to the faucet. The filter unit screws into the bottom of the white housing. The valve takes some getting used to though. It's a little pin that you pull to switch to the filter and is held in place by the water pressure and releases when you stop the flow. There's also no indicator for when to switch the filter, so you have to judge it by taste or just replace it at regular intervals.
Since you're in a house though, you should look into one of the under sink units or something larger even. Assuming you'll be there for a while, the larger undersink units perform much better and have a much lower long term cost. Something like what jc9394 recommended would be miles and away better than anything faucet mounted.