Long awaited development will include two towers of 42 and 26 storeys