One of the oldest buildings at University College Cork (UCC) has opened for the first time as a state of the art, one-stop-shop for students following a multi-million euro transformation.