Firstly, there are some errors in your original attempt's code (too many columns, multirow definition in wrong place). So our starting point code should be as below:
\documentclass[12pt,a4paper]{article}
\usepackage{booktabs}
\usepackage{multirow}
\begin{document}
\begin{tabular}{ccc}
\toprule
\multirow{2}{*}{Principal actor in rule adoption process}
& \multicolumn{2}{c}{Logic of rule adoption} \\
\cmidrule{2-3}
& Logic of consequences & Logic of appropriateness \\
\midrule
EU-driven & External incentives model & Social learning model \\
CEE-driven & Lesson-drawing model & Lesson-drawing model \\
\bottomrule
\end{tabular}
\end{document}
What seems like it should work is to convert the columns into paragraph (wrapped) ones; you can use the array package and special p definitions to make them centered. (I'm assuming you need them to stay centered.) I also added a \noindent in so that table doesn't get a paragraph indent before it (common practice).
\documentclass[12pt,a4paper]{article}
\usepackage{booktabs}% http://ctan.org/pkg/booktabs
\usepackage{multirow}
\usepackage{array}
\begin{document}
\noindent
\begin{tabular}%
{>{\centering\arraybackslash}p{0.3\textwidth}%
>{\centering\arraybackslash}p{0.3\textwidth}%
>{\centering\arraybackslash}p{0.3\textwidth}}
\toprule
\multirow{2}{*}{Principal actor in rule adoption process}
& \multicolumn{2}{c}{Logic of rule adoption} \\
\cmidrule{2-3}
& Logic of consequences
& Logic of appropriateness \\
\midrule
EU-driven & External incentives model & Social learning model \\
CEE-driven & Lesson-drawing model & Lesson-drawing model \\
\bottomrule
\end{tabular}
\end{document}
However, this doesn't work because multirow doesn't 'honour' the paragraph column definition and so the text is not wrapped. (The multirow documentation doesn't mention this 'feature', and it surprises me that this isn't mentioned in any other answers to this and similar questions since, to me, this is very unintuitive.)
So we need to wrap the multirow in a parbox to 'reapply the column formatting manually':
\documentclass[12pt,a4paper]{article}
\usepackage{booktabs}% http://ctan.org/pkg/booktabs
\usepackage{multirow}
\usepackage{array}
\begin{document}
\noindent
\begin{tabular}%
{>{\centering\arraybackslash}p{0.3\textwidth}%
>{\centering\arraybackslash}p{0.3\textwidth}%
>{\centering\arraybackslash}p{0.3\textwidth}}
\toprule
\multirow{2}{*}{\parbox{0.3\textwidth}{\centering Principal actor in rule adoption process}}
& \multicolumn{2}{c}{Logic of rule adoption} \\
\cmidrule{2-3}
& Logic of consequences
& Logic of appropriateness \\
\midrule
EU-driven & External incentives model & Social learning model \\
CEE-driven & Lesson-drawing model & Lesson-drawing model \\
\bottomrule
\end{tabular}
\end{document}
You could revert back to {ccc} column definitions and have a parbox of a fixed width <= any other row contents for that column, but that's a bit clunky. Better to leave them like this and have the benefit of wrapped, centered text everywhere.
EDIT: Actually, it also works if you just set the multirow width manually:
\multirow{2}{0.3\textwidth}{\centering Principal actor in rule adoption process}}
This is perhaps a cleaner solution, but it's a bit mysterious why specifying the width manually (cf. *) causes it to start wrapping, but not to get the centering until added manually. (I assume because a specified width implicitly applies paragraph-style wrapping.) At least using a parbox makes it explicit.
EDIT 2: To be more generic, this works if you use \linewidth instead of \textwidth everywhere, with a multirow width of \linewidth (not 0.3\linewidth). \linewidth appears to give you the contextual width which, in a table cell, is the column width. However, no descriptions of \linewidth I've seen (including comprehensive answers on this site: Difference between \textwidth, \linewidth and \hsize) mention this tabular context (they all talk about lists, minipages and parboxes), so I was very surprised that this works like this. Maybe it's because parboxes are being used under the covers(?), or perhaps \linewidth is more general than people realise?
\multirow{-2}{*}{...}instead to make the overlap span vertically upward rather than downward. – Werner Nov 24 '11 at 17:08