The €6m revamp of an historic Cork city quay which will include the city's first flood defences has been given the go-ahead.