Party palaces and bachelor pads have had their day – it’s time for a home with practical credentials. But there’s no need to sacrifice style for substance