When a mounted DMG is the foreground window, Finder should slightly adjust the .app handler. The default action will be "Install Application," which will pop up a confirmation window and, if confirmed, copy the application to /Applications.

The "Open" option should still be available for people who, for whatever reason, want to run an application directly from a DMG.