The council said the proposed scheme will 'transform' the existing car park