Ambitious plans for a development that will include Cork’s largest hotel have been given the go-ahead by An Bord Pleanála.