Hotel will form part of a £42m renovation of the international cricket stadium, allowing it to operate all year round.