The popular Aberdeen nightclub will reopen this weekend.