This is exactly my problem too. I had no ideal how to go about DIY. I would be open to it, but would need lots of help. Unfortunately I don't know anyone with a marine tank to ask.
If I could just go somewhere and see a tank/sump/stand unit that looks tidy I'd be happy. I'm really keen to get something that looks like a nice piece of furniture as well. I have seen some setups online that look quite untidy. That might be a bit too picky but as looking to have a setup in the lounge would like something that looks nice overall too.