A play area has been destroyed by a "disgusting act of arson", a councillor has said