A council leader has hit out at police over a decision to shelve a seven-year fraud investigation sparked by a whistleblower raising serious concerns.