<p>Is there a way to enable STRICT_ALL_TABLES for a single MySQL database?</p>

Don't think you can do this directly but you might get close with setting Strict for the current session when working on a particular database. Could do this in the config files of specific users.