May I recommend a Pembroke welsh corgi?
They aren't really *Small* dogs. They're just sort of ... um... short. :-)
They're great in the house, definitely know the difference between down time and job time, and they are A1 nappers! (gotta conserve that energy for when it's needed.) But they...