try this:

select 0 as [@id]

, (select 'Valuta' as [@name]

, Valuta as [@value]

from #prova

for xml path('dim'), type)

, (select 'Misura' as [@name]

, Misura as [@value]

from #prova

for xml path('dim'), type)

for xml path('obs'), root('root')