The restoration of Sir John Soane's Museum offers an enticing new view of one of the world's most sumptuous architectural treats, says Jay Merrick