The Hangover star is to take on the role of the bumbling detective following the death of Leslie Nielsen in 2010