Experts have warned investments offered by cash-strapped councils to fund net-zero projects are "underwhelming" and could be difficult to get money out of.