Hotel Indigo Exeter has opened its doors to guests after a multi-million-pound major restoration project.