Renovated Red Sea Corniche officially opens today