http://www.dubaiairshow.org
yes its open to public, and photography is allowed. Any hotel in Diera should be good enough for you (Sheraton Creek, Radisson SAS, Le Meridian Sundus, Sofitel City Center, etc .. ) there is a link for travel agents on the site.