I keep all of my tanks in the living room. But I don't have a normal living room, it's like an L shape. So I have my 2 biggest on the long part of the L and my smallest on the end of the short part, facing the long part, if you know what I mean.
I think well kept fishtanks make a brilliant focal point for any home.