I'm gonna say you probably don't want to go the route I did. I've got a leonberger and while he's perfect for me, I've also got a house with enough room so...
offhand, some sort of Collie mix might work out. Collies tend to be pretty great and mixes even better. We had a cocker-collie when I was in high school and she was the BEST.