Such a site already exists: fixmystreet.com. Most councils already use it (or an instanced version of it), and every time I've found an issue in public, it has already been reported on there. Often multiple times.
The issue is, as you say, the council doesn't have the budget to actually fix the reported problems.
