Critical investment into Portsmouth Naval Base has been hailed as “fantastic news” for the city.