Boot straight to an Application when Mac is turned on
See This Apple Tech Note on creating a kiosk type UI in OS X. Be careful you configure a way to boot normally, in case of mis-configuration, application starts hanging, etc.