Portsmouth City Council has welcomed the possibility of a devolution deal for Hampshire with cautious optimism.