The Whitney Houston-themed musical will be hosted at Manchester's Opera House.