Major plans for the restoration of one of Oxford's most famous pubs have been given the go-ahead by civic chiefs.