For 88 years, it was Northampton's lost gem - a house entirely fitted out by designer Charles Rennie Mackintosh. Having miraculously survived in obscurity, the interior is now gloriously restored as a museum. Oliver Bennett visits the Scotsman's last hurrah.