For SQL Server 2005, both Standard and Enterprise Edition supports clustering. SQL Server 2005 Standard Edition supports up to two nodes clustering. Now for most scenario this is OK already.
Please note however that this only applies to SQL Server. Your operating system still has to run on an Enterprise Edition.