Right now when I publish the Publish HTML Design page, it will push all design resource to one of the site folder. Is there anyway I can modify it to publish all resource to CDN?
If you want to rewrite (some of) the links generated by DXA, you can implement your own Link Resolver.
You find the default Link Resolver implementation (.NET) here: https://github.com/sdl/dxa-web-application-dotnet/blob/master/Sdl.Web.Tridion/Linking/DefaultLinkResolver.cs
Your custom Link Resolver could call the Default Link Resolver and the post-process the resolved site URL.
You can register your custom Link Resolver in
Based on comment, it seems that you are looking for strategy to clear the resource from Akamai. Given below are the details based on that assumption.
CDN caching can be cleared using the querystring parameters. On Akamai you can set it query for the resource again.
To achieve this, you can create a TBB that will add timestamp to the url after which your url will be: http://examplesite.com/resourcefolder/52/xxx.js?v=201609192311. Now if you publish a new version of the same resource again, the url will be http://examplesite.com/resourcefolder/52/xxx.js?v=201609192316 and since Akamai set to query for resource as url has changed, you will get the latest resource.