Historic Portsmouth waterside site set for overhaul