The dilapidated offices where plans for the Titanic were drawn up are to be re-opened as part of a £5m (€5.9m) regeneration project.