I find it interesting that you have a dog who is hyper and you are worried about a cat being a PITA? Cats are very low maintenance in comparison to needy dogs.
If you are going to get a kitten, it will easily get used to a dog. And many adoption agencies use foster families to socialize their cats and many of those have dogs. So if you specify you want a cat who is ok with dogs you will find there are plenty that are available.
We don't have carpets and we don't have any furniture that the cats are scratching. I have a cat tree in the livingroom, a box (corrugated cardboard cat scratcher) in my office, a door hanging thingy on a door knob, and
I bought some really really cheap carpet for my cats (just a 6 foot by 2 foot piece of it) to scratch on too.
I also trim toenails, maybe not as often as i should. And i have the cat litter in the basement where I don't have to smell it every day.
oh, and if you feed high quality food, the feces don't smell so bad.