A £5m revamp of an area at the heart of Belfast will create “a unique, world-class public space” and cultural hub, the city’s council says.