A new Belfast hospital venue will open next week as part of a £3 million investment by the owners of Haymarket.