A man has died following stabbing in an inner-city Brisbane unit in the early hours of Sunday morning, sparking a homicide investigation.